select * from products where pro_name like '%Train%dresses%' or pro_des like '%Train%dresses%'union all select * from products where (pro_name like '%Train%' or pro_des like '%Train%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Train%dresses%' or pro_des not like '%Train%dresses%')
Blue Half Sleeves Tulle Brush Train Zipper Girls Pageant Dresses for Wedding Party
Fancy Sleeveless Sweep Train Lace Up Embroidery and Ruffles Sweet 16 Dresses
Glorious Sleeveless Brush Train Lace Up Beading Court Dresses for Sweet 16
Free and Easy Sleeveless Sweep Train Embroidery and Ruffles Lace Up Sweet 16 Dresses
Custom Designed Sleeveless Brush Train Zipper Lace Flower Girl Dresses for Less
Taffeta One Shoulder Royal Blue Dama Quinceanera Dress with Pleat
Chiffon Light Pink One Shoulder Quinceanera Dama Dress with Ruches
Chiffon Light Yellow Dama Quince Dress with Hand Made Flowers
Halter Top Spring Green Knee-length Chiffon Dama Dress 2014
Wine Red One Shoulder Chiffon Knee-length Dama Dress for Cheap
Red V-neck Knee-length Quinceanera Dama Dress with Pleat in Satin
Wine Red Dama Quinceanera Dress with Straps in Chiffon and Satin
Apple Green V-neck Chiffon Quinceanera Dress for Dama with a Sash
Sweetheart Watermelon Dama Dress with Ruches and a Brush Train
Brown Mini-length Dama Dress with Spaghetti Straps in Chiffon
Satin Light Blue Dama Dress with a Brush Train and a Sash
Chiffon V-neck Lilac Dama Dress With Ruches in Knee-length
Olive Green Knee-length Chiffon Sweet 15 Dama Dress with a Sash
Chiffon White Sweet 15 Dama Dress with Ruches in Knee-length
Roes Pink V-neck Mini-length Dama Dress with Ruches in Chiffon
Chiffon V-neck Roral Blue Dama Dress With Ruches and a Sash
Turquoise Knee-length Dama Dress with a Bow and Spaghetti Straps
Black Chiffon Dama Dress with Ruches and Spaghetti Straps
One Shoulder Light Yellow Dama Dress with Ruches in Chiffon
Violet Red Chiffon Dama Gown with Rushes and a Hand Made Flower
Strapless Light Pink Dama Dress with Ruches in Chiffon
Halter Top Olive Green Dama Dress with Ruches in Chiffon
Watermelon Dama Dress with Ruches and Hand Made Flower